package com.crk.mapper;

import com.crk.entity.Hospitals;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author com.crk
 * @since 2021-03-30
 */
public interface HospitalsMapper extends BaseMapper<Hospitals> {

	@Select("select * from hospitals where hospital_level>#{ownlevel}")
	public List<Hospitals> selectLowHos(Integer ownlevel);
	
	
	@Select("select * from hospitals where hospital_level<#{ownlevel}")
	public List<Hospitals> selectSenHos(Integer ownlevel);
}
